Pandas Profiling Report

Dataset statistics

Number of variables	19
Number of observations	100000
Missing cells	95887
Missing cells (%)	5.0%
Duplicate rows	10215
Duplicate rows (%)	10.2%
Total size in memory	14.5 MiB
Average record size in memory	152.0 B

Variable types

Categorical	7
Numeric	12

Alerts

Dataset has 10215 (10.2%) duplicate rows	Duplicates
`Loan ID` has a high cardinality: 81999 distinct values	High cardinality
`Customer ID` has a high cardinality: 81999 distinct values	High cardinality
`Annual Income` is highly correlated with `Monthly Debt`	High correlation
`Monthly Debt` is highly correlated with `Current Credit Balance`	High correlation
`Number of Credit Problems` is highly correlated with `Bankruptcies` and 1 other fields	High correlation
`Current Credit Balance` is highly correlated with `Monthly Debt`	High correlation
`Maximum Open Credit` is highly correlated with `Current Credit Balance`	High correlation
`Bankruptcies` is highly correlated with `Number of Credit Problems`	High correlation
`Tax Liens` is highly correlated with `Number of Credit Problems`	High correlation
`Loan Status` is highly correlated with `Credit Score`	High correlation
`Credit Score` is highly correlated with `Loan Status`	High correlation
`Home Ownership` is highly correlated with `Purpose`	High correlation
`Purpose` is highly correlated with `Home Ownership`	High correlation
`Credit Score` has 19154 (19.2%) missing values	Missing
`Annual Income` has 19154 (19.2%) missing values	Missing
`Years in current job` has 4222 (4.2%) missing values	Missing
`Months since last delinquent` has 53141 (53.1%) missing values	Missing
`Annual Income` is highly skewed (γ1 = 46.88869873)	Skewed
`Maximum Open Credit` is highly skewed (γ1 = 132.6388749)	Skewed
`Loan ID` is uniformly distributed	Uniform
`Customer ID` is uniformly distributed	Uniform
`Number of Credit Problems` has 86035 (86.0%) zeros	Zeros
`Bankruptcies` has 88774 (88.8%) zeros	Zeros
`Tax Liens` has 98062 (98.1%) zeros	Zeros

Reproduction

Analysis started	2022-12-15 10:05:10.108191
Analysis finished	2022-12-15 10:05:28.182106
Duration	18.07 seconds
Software version	pandas-profiling v3.3.0
Download configuration	config.json

Loan ID
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	81999
Distinct (%)	82.0%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

14dd8831-6af5-400b-83ec-68e61888a048	2
1373bfdf-ae6d-4fa5-b3e9-73ba60b7868e	2
111602d9-f958-403d-a9d5-4fba630297eb	2
1076b681-b8ff-463f-a7af-576e12edd637	2
f7817002-4e22-4462-8abc-402eb4ceaa6c	2
Other values (81994)	99990

Length

Max length	36
Median length	36
Mean length	36
Min length	36

Characters and Unicode

Total characters	3600000
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	63998 ?
Unique (%)	64.0%

Sample

1st row	14dd8831-6af5-400b-83ec-68e61888a048
2nd row	4771cc26-131a-45db-b5aa-537ea4ba5342
3rd row	4eed4e6a-aa2f-4c91-8651-ce984ee8fb26
4th row	77598f7b-32e7-4e3b-a6e5-06ba0d98fe8a
5th row	d4062e70-befa-4995-8643-a0de73938182

Common Values

Value	Count	Frequency (%)
14dd8831-6af5-400b-83ec-68e61888a048	2	< 0.1%
1373bfdf-ae6d-4fa5-b3e9-73ba60b7868e	2	< 0.1%
111602d9-f958-403d-a9d5-4fba630297eb	2	< 0.1%
1076b681-b8ff-463f-a7af-576e12edd637	2	< 0.1%
f7817002-4e22-4462-8abc-402eb4ceaa6c	2	< 0.1%
cbad155d-99e3-4cb5-b8ef-dc8ad694488c	2	< 0.1%
d9add07d-0988-4f3d-838d-a42a4fbd05ce	2	< 0.1%
96638bcb-d939-41b0-9bb5-d951d6a4dcc2	2	< 0.1%
52d510dd-c367-4472-b450-125bb66f3288	2	< 0.1%
1c6d8406-97bb-416d-a416-701afb398983	2	< 0.1%
Other values (81989)	99980	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
14dd8831-6af5-400b-83ec-68e61888a048	2	< 0.1%
4795c1ce-0d77-400a-b370-0ffc7b688a0d	2	< 0.1%
1585509a-1a31-4460-949f-2624ed054176	2	< 0.1%
4c6d5ca9-b4f7-4724-b60d-4c39919f33dd	2	< 0.1%
070efe1e-7911-4927-b466-e7541fc557a3	2	< 0.1%
6eb14cde-2de6-48df-a6dc-72527642d105	2	< 0.1%
e8f5ca19-f3f7-487f-aba7-26c0b600a7a3	2	< 0.1%
c9488ac4-87ed-4da7-bdda-194e7d828894	2	< 0.1%
9fe9322c-fb7b-4777-a763-a6ec220e4d53	2	< 0.1%
95533358-c862-4fdb-9ca9-0b2124209247	2	< 0.1%
Other values (81989)	99980	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
-	400000	11.1%
4	287551	8.0%
a	212644	5.9%
9	212346	5.9%
b	211946	5.9%
8	211864	5.9%
0	188172	5.2%
2	188148	5.2%
c	188078	5.2%
7	187813	5.2%
Other values (7)	1311438	36.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2025282	56.3%
Lowercase Letter	1174718	32.6%
Dash Punctuation	400000	11.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
4	287551	14.2%
9	212346	10.5%
8	211864	10.5%
0	188172	9.3%
2	188148	9.3%
7	187813	9.3%
1	187606	9.3%
5	187480	9.3%
3	187225	9.2%
6	187077	9.2%

Lowercase Letter

Value	Count	Frequency (%)
a	212644	18.1%
b	211946	18.0%
c	188078	16.0%
e	187476	16.0%
d	187374	16.0%
f	187200	15.9%

Dash Punctuation

Value	Count	Frequency (%)
-	400000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2425282	67.4%
Latin	1174718	32.6%

Most frequent character per script

Common

Value	Count	Frequency (%)
-	400000	16.5%
4	287551	11.9%
9	212346	8.8%
8	211864	8.7%
0	188172	7.8%
2	188148	7.8%
7	187813	7.7%
1	187606	7.7%
5	187480	7.7%
3	187225	7.7%

Latin

Value	Count	Frequency (%)
a	212644	18.1%
b	211946	18.0%
c	188078	16.0%
e	187476	16.0%
d	187374	16.0%
f	187200	15.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3600000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	400000	11.1%
4	287551	8.0%
a	212644	5.9%
9	212346	5.9%
b	211946	5.9%
8	211864	5.9%
0	188172	5.2%
2	188148	5.2%
c	188078	5.2%
7	187813	5.2%
Other values (7)	1311438	36.4%

Customer ID
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	81999
Distinct (%)	82.0%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

981165ec-3274-42f5-a3b4-d104041a9ca9	2
3b5f11f9-0951-43e2-bed5-d24d1e4e8b76	2
add9dac6-c1ad-4441-ba96-274fbf493379	2
7bc16148-ec0a-4b75-89fc-20ca13350175	2
3b561060-1b20-4c36-95c2-9a9b1bf54195	2
Other values (81994)	99990

Length

Max length	36
Median length	36
Mean length	36
Min length	36

Characters and Unicode

Total characters	3600000
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	63998 ?
Unique (%)	64.0%

Sample

1st row	981165ec-3274-42f5-a3b4-d104041a9ca9
2nd row	2de017a3-2e01-49cb-a581-08169e83be29
3rd row	5efb2b2b-bf11-4dfd-a572-3761a2694725
4th row	e777faab-98ae-45af-9a86-7ce5b33b1011
5th row	81536ad9-5ccf-4eb8-befb-47a4d608658e

Common Values

Value	Count	Frequency (%)
981165ec-3274-42f5-a3b4-d104041a9ca9	2	< 0.1%
3b5f11f9-0951-43e2-bed5-d24d1e4e8b76	2	< 0.1%
add9dac6-c1ad-4441-ba96-274fbf493379	2	< 0.1%
7bc16148-ec0a-4b75-89fc-20ca13350175	2	< 0.1%
3b561060-1b20-4c36-95c2-9a9b1bf54195	2	< 0.1%
f4eed63c-0c95-4ffa-bf31-585c73ff3f91	2	< 0.1%
a42ab3d2-db8b-4d20-a357-f26c7a6f10b5	2	< 0.1%
5c5731e6-64da-4e40-a0d2-f858957263ae	2	< 0.1%
9606e990-2ab6-4e5d-ba59-a4cf61254b48	2	< 0.1%
6a03d0e7-5d8d-4399-a944-236f40224d31	2	< 0.1%
Other values (81989)	99980	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
981165ec-3274-42f5-a3b4-d104041a9ca9	2	< 0.1%
02a9a103-ce6d-4d24-ad1d-1e68074a0e75	2	< 0.1%
6d13a492-d15a-4f16-9785-4751d947bf64	2	< 0.1%
89a9a394-95eb-46e0-aabc-d1dd39dbbc25	2	< 0.1%
9cf7c200-a608-4404-883a-17964f19e3c3	2	< 0.1%
260c52a3-46b8-4cdc-89e7-352960557344	2	< 0.1%
69f7f1af-4464-4d8b-8c41-17d15b7b5e4d	2	< 0.1%
123b0aba-90c7-4d67-9d17-d8566fd91e74	2	< 0.1%
f1cb42a4-a25d-4cc6-8cdf-94c147ec9906	2	< 0.1%
eeb8789e-5124-4854-9aab-7aa178d0f82e	2	< 0.1%
Other values (81989)	99980	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
-	400000	11.1%
4	287889	8.0%
a	212705	5.9%
8	212170	5.9%
b	211850	5.9%
9	211791	5.9%
c	188049	5.2%
e	188024	5.2%
7	187963	5.2%
5	187790	5.2%
Other values (7)	1311769	36.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2024943	56.2%
Lowercase Letter	1175057	32.6%
Dash Punctuation	400000	11.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
4	287889	14.2%
8	212170	10.5%
9	211791	10.5%
7	187963	9.3%
5	187790	9.3%
6	187624	9.3%
3	187601	9.3%
1	187434	9.3%
0	187400	9.3%
2	187281	9.2%

Lowercase Letter

Value	Count	Frequency (%)
a	212705	18.1%
b	211850	18.0%
c	188049	16.0%
e	188024	16.0%
d	187287	15.9%
f	187142	15.9%

Dash Punctuation

Value	Count	Frequency (%)
-	400000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2424943	67.4%
Latin	1175057	32.6%

Most frequent character per script

Common

Value	Count	Frequency (%)
-	400000	16.5%
4	287889	11.9%
8	212170	8.7%
9	211791	8.7%
7	187963	7.8%
5	187790	7.7%
6	187624	7.7%
3	187601	7.7%
1	187434	7.7%
0	187400	7.7%

Latin

Value	Count	Frequency (%)
a	212705	18.1%
b	211850	18.0%
c	188049	16.0%
e	188024	16.0%
d	187287	15.9%
f	187142	15.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3600000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	400000	11.1%
4	287889	8.0%
a	212705	5.9%
8	212170	5.9%
b	211850	5.9%
9	211791	5.9%
c	188049	5.2%
e	188024	5.2%
7	187963	5.2%
5	187790	5.2%
Other values (7)	1311769	36.4%

Loan Status
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

Fully Paid	77361
Charged Off	22639

Length

Max length	11
Median length	10
Mean length	10.22639
Min length	10

Characters and Unicode

Total characters	1022639
Distinct characters	16
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Fully Paid
2nd row	Fully Paid
3rd row	Fully Paid
4th row	Fully Paid
5th row	Fully Paid

Common Values

Value	Count	Frequency (%)
Fully Paid	77361	77.4%
Charged Off	22639	22.6%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
fully	77361	38.7%
paid	77361	38.7%
charged	22639	11.3%
off	22639	11.3%

Most occurring characters

Value	Count	Frequency (%)
l	154722	15.1%
	100000	9.8%
a	100000	9.8%
d	100000	9.8%
F	77361	7.6%
u	77361	7.6%
y	77361	7.6%
P	77361	7.6%
i	77361	7.6%
f	45278	4.4%
Other values (6)	135834	13.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	722639	70.7%
Uppercase Letter	200000	19.6%
Space Separator	100000	9.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
l	154722	21.4%
a	100000	13.8%
d	100000	13.8%
u	77361	10.7%
y	77361	10.7%
i	77361	10.7%
f	45278	6.3%
h	22639	3.1%
r	22639	3.1%
g	22639	3.1%

Uppercase Letter

Value	Count	Frequency (%)
F	77361	38.7%
P	77361	38.7%
C	22639	11.3%
O	22639	11.3%

Space Separator

Value	Count	Frequency (%)
	100000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	922639	90.2%
Common	100000	9.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
l	154722	16.8%
a	100000	10.8%
d	100000	10.8%
F	77361	8.4%
u	77361	8.4%
y	77361	8.4%
P	77361	8.4%
i	77361	8.4%
f	45278	4.9%
C	22639	2.5%
Other values (5)	113195	12.3%

Common

Value	Count	Frequency (%)
	100000	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1022639	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
l	154722	15.1%
	100000	9.8%
a	100000	9.8%
d	100000	9.8%
F	77361	7.6%
u	77361	7.6%
y	77361	7.6%
P	77361	7.6%
i	77361	7.6%
f	45278	4.4%
Other values (6)	135834	13.3%

Current Loan Amount
Real number (ℝ_≥0)

Distinct	22004
Distinct (%)	22.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11760447.39

Minimum	10802
Maximum	99999999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	10802
5-th percentile	76054
Q1	179652
median	312246
Q3	524942
95-th percentile	99999999
Maximum	99999999
Range	99989197
Interquartile range (IQR)	345290

Descriptive statistics

Standard deviation	31783942.55
Coefficient of variation (CV)	2.702613387
Kurtosis	3.837366224
Mean	11760447.39
Median Absolute Deviation (MAD)	147664
Skewness	2.415986608
Sum	1.176044739 × 10¹²
Variance	1.010219004 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
99999999	11484	11.5%
223102	27	< 0.1%
223322	27	< 0.1%
216194	27	< 0.1%
223652	27	< 0.1%
108966	26	< 0.1%
222596	26	< 0.1%
214962	25	< 0.1%
216810	25	< 0.1%
179828	25	< 0.1%
Other values (21994)	88281	88.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10802	1	< 0.1%
11242	1	< 0.1%
15422	2	< 0.1%
21098	1	< 0.1%
21450	3	< 0.1%
21472	9	< 0.1%
21494	3	< 0.1%
21516	6	< 0.1%
21538	7	< 0.1%
21560	4	< 0.1%

Value	Count	Frequency (%)
99999999	11484	11.5%
789250	3	< 0.1%
789184	6	< 0.1%
789096	16	< 0.1%
789030	9	< 0.1%
788942	9	< 0.1%
788876	4	< 0.1%
788788	5	< 0.1%
788722	2	< 0.1%
788634	8	< 0.1%

Term
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

Short Term	72208
Long Term	27792

Length

Max length	10
Median length	10
Mean length	9.72208
Min length	9

Characters and Unicode

Total characters	972208
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Short Term
2nd row	Short Term
3rd row	Short Term
4th row	Long Term
5th row	Short Term

Common Values

Value	Count	Frequency (%)
Short Term	72208	72.2%
Long Term	27792	27.8%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
term	100000	50.0%
short	72208	36.1%
long	27792	13.9%

Most occurring characters

Value	Count	Frequency (%)
r	172208	17.7%
o	100000	10.3%
	100000	10.3%
T	100000	10.3%
e	100000	10.3%
m	100000	10.3%
S	72208	7.4%
h	72208	7.4%
t	72208	7.4%
L	27792	2.9%
Other values (2)	55584	5.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	672208	69.1%
Uppercase Letter	200000	20.6%
Space Separator	100000	10.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	172208	25.6%
o	100000	14.9%
e	100000	14.9%
m	100000	14.9%
h	72208	10.7%
t	72208	10.7%
n	27792	4.1%
g	27792	4.1%

Uppercase Letter

Value	Count	Frequency (%)
T	100000	50.0%
S	72208	36.1%
L	27792	13.9%

Space Separator

Value	Count	Frequency (%)
	100000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	872208	89.7%
Common	100000	10.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	172208	19.7%
o	100000	11.5%
T	100000	11.5%
e	100000	11.5%
m	100000	11.5%
S	72208	8.3%
h	72208	8.3%
t	72208	8.3%
L	27792	3.2%
n	27792	3.2%

Common

Value	Count	Frequency (%)
	100000	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	972208	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	172208	17.7%
o	100000	10.3%
	100000	10.3%
T	100000	10.3%
e	100000	10.3%
m	100000	10.3%
S	72208	7.4%
h	72208	7.4%
t	72208	7.4%
L	27792	2.9%
Other values (2)	55584	5.7%

Credit Score
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	324
Distinct (%)	0.4%
Missing	19154
Missing (%)	19.2%
Infinite	0
Infinite (%)	0.0%
Mean	1076.456089

Minimum	585
Maximum	7510
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	585
5-th percentile	661
Q1	705
median	724
Q3	741
95-th percentile	6690
Maximum	7510
Range	6925
Interquartile range (IQR)	36

Descriptive statistics

Standard deviation	1475.403791
Coefficient of variation (CV)	1.370612147
Kurtosis	12.97183192
Mean	1076.456089
Median Absolute Deviation (MAD)	17
Skewness	3.86322527
Sum	87027169
Variance	2176816.348
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
747	1825	1.8%
740	1746	1.7%
746	1742	1.7%
741	1732	1.7%
742	1723	1.7%
739	1624	1.6%
745	1612	1.6%
748	1598	1.6%
743	1555	1.6%
725	1548	1.5%
Other values (314)	64141	64.1%
(Missing)	19154	19.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
585	12	< 0.1%
586	7	< 0.1%
587	11	< 0.1%
588	20	< 0.1%
589	6	< 0.1%
590	8	< 0.1%
591	9	< 0.1%
592	4	< 0.1%
593	7	< 0.1%
594	10	< 0.1%

Value	Count	Frequency (%)
7510	9	< 0.1%
7500	24	< 0.1%
7490	23	< 0.1%
7480	43	< 0.1%
7470	51	0.1%
7460	76	0.1%
7450	55	0.1%
7440	58	0.1%
7430	70	0.1%
7420	84	0.1%

Annual Income
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
SKEWED

Distinct	36174
Distinct (%)	44.7%
Missing	19154
Missing (%)	19.2%
Infinite	0
Infinite (%)	0.0%
Mean	1378276.56

Minimum	76627
Maximum	165557393
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	76627
5-th percentile	519863.75
Q1	848844
median	1174162
Q3	1650663
95-th percentile	2810579.75
Maximum	165557393
Range	165480766
Interquartile range (IQR)	801819

Descriptive statistics

Standard deviation	1081360.196
Coefficient of variation (CV)	0.7845741756
Kurtosis	6624.167709
Mean	1378276.56
Median Absolute Deviation (MAD)	380703
Skewness	46.88869873
Sum	1.114281468 × 10¹¹
Variance	1.169339873 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1162572	22	< 0.1%
973370	19	< 0.1%
969475	18	< 0.1%
1140000	18	< 0.1%
1143762	17	< 0.1%
949905	17	< 0.1%
1112640	17	< 0.1%
953230	17	< 0.1%
1320291	17	< 0.1%
1166220	17	< 0.1%
Other values (36164)	80667	80.7%
(Missing)	19154	19.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
76627	1	< 0.1%
81092	1	< 0.1%
94867	1	< 0.1%
97033	1	< 0.1%
106533	1	< 0.1%
111245	2	< 0.1%
130150	1	< 0.1%
134881	2	< 0.1%
135071	2	< 0.1%
144267	2	< 0.1%

Value	Count	Frequency (%)
165557393	1	< 0.1%
36475440	1	< 0.1%
30838995	1	< 0.1%
28095300	1	< 0.1%
24161540	1	< 0.1%
23980375	1	< 0.1%
22448880	2	< 0.1%
19019000	1	< 0.1%
18768200	2	< 0.1%
18743937	1	< 0.1%

Years in current job
Categorical

MISSING

Distinct	11
Distinct (%)	< 0.1%
Missing	4222
Missing (%)	4.2%
Memory size	781.4 KiB

10+ years	31121
2 years	9134
3 years	8169
< 1 year	8164
5 years	6787
Other values (6)	32403

Length

Max length	9
Median length	7
Mean length	7.667648103
Min length	6

Characters and Unicode

Total characters	734392
Distinct characters	18
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	8 years
2nd row	10+ years
3rd row	8 years
4th row	3 years
5th row	5 years

Common Values

Value	Count	Frequency (%)
10+ years	31121	31.1%
2 years	9134	9.1%
3 years	8169	8.2%
< 1 year	8164	8.2%
5 years	6787	6.8%
1 year	6460	6.5%
4 years	6143	6.1%
6 years	5686	5.7%
7 years	5577	5.6%
8 years	4582	4.6%
(Missing)	4222	4.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
years	81154	40.6%
10	31121	15.6%
1	14624	7.3%
year	14624	7.3%
2	9134	4.6%
3	8169	4.1%
	8164	4.1%
5	6787	3.4%
4	6143	3.1%
6	5686	2.8%
Other values (3)	14114	7.1%

Most occurring characters

Value	Count	Frequency (%)
	103942	14.2%
y	95778	13.0%
e	95778	13.0%
a	95778	13.0%
r	95778	13.0%
s	81154	11.1%
1	45745	6.2%
0	31121	4.2%
+	31121	4.2%
2	9134	1.2%
Other values (8)	49063	6.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	464266	63.2%
Decimal Number	126899	17.3%
Space Separator	103942	14.2%
Math Symbol	39285	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	45745	36.0%
0	31121	24.5%
2	9134	7.2%
3	8169	6.4%
5	6787	5.3%
4	6143	4.8%
6	5686	4.5%
7	5577	4.4%
8	4582	3.6%
9	3955	3.1%

Lowercase Letter

Value	Count	Frequency (%)
y	95778	20.6%
e	95778	20.6%
a	95778	20.6%
r	95778	20.6%
s	81154	17.5%

Math Symbol

Value	Count	Frequency (%)
+	31121	79.2%
<	8164	20.8%

Space Separator

Value	Count	Frequency (%)
	103942	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	464266	63.2%
Common	270126	36.8%

Most frequent character per script

Common

Value	Count	Frequency (%)
	103942	38.5%
1	45745	16.9%
0	31121	11.5%
+	31121	11.5%
2	9134	3.4%
3	8169	3.0%
<	8164	3.0%
5	6787	2.5%
4	6143	2.3%
6	5686	2.1%
Other values (3)	14114	5.2%

Latin

Value	Count	Frequency (%)
y	95778	20.6%
e	95778	20.6%
a	95778	20.6%
r	95778	20.6%
s	81154	17.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	734392	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	103942	14.2%
y	95778	13.0%
e	95778	13.0%
a	95778	13.0%
r	95778	13.0%
s	81154	11.1%
1	45745	6.2%
0	31121	4.2%
+	31121	4.2%
2	9134	1.2%
Other values (8)	49063	6.7%

Home Ownership
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

Home Mortgage	48410
Rent	42194
Own Home	9182
HaveMortgage	214

Length

Max length	13
Median length	12
Mean length	8.7413
Min length	4

Characters and Unicode

Total characters	874130
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Home Mortgage
2nd row	Home Mortgage
3rd row	Own Home
4th row	Own Home
5th row	Rent

Common Values

Value	Count	Frequency (%)
Home Mortgage	48410	48.4%
Rent	42194	42.2%
Own Home	9182	9.2%
HaveMortgage	214	0.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
home	57592	36.5%
mortgage	48410	30.7%
rent	42194	26.8%
own	9182	5.8%
havemortgage	214	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	148624	17.0%
o	106216	12.2%
g	97248	11.1%
t	90818	10.4%
H	57806	6.6%
m	57592	6.6%
	57592	6.6%
n	51376	5.9%
a	48838	5.6%
M	48624	5.6%
Other values (5)	109396	12.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	658732	75.4%
Uppercase Letter	157806	18.1%
Space Separator	57592	6.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	148624	22.6%
o	106216	16.1%
g	97248	14.8%
t	90818	13.8%
m	57592	8.7%
n	51376	7.8%
a	48838	7.4%
r	48624	7.4%
w	9182	1.4%
v	214	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
H	57806	36.6%
M	48624	30.8%
R	42194	26.7%
O	9182	5.8%

Space Separator

Value	Count	Frequency (%)
	57592	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	816538	93.4%
Common	57592	6.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	148624	18.2%
o	106216	13.0%
g	97248	11.9%
t	90818	11.1%
H	57806	7.1%
m	57592	7.1%
n	51376	6.3%
a	48838	6.0%
M	48624	6.0%
r	48624	6.0%
Other values (4)	60772	7.4%

Common

Value	Count	Frequency (%)
	57592	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	874130	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	148624	17.0%
o	106216	12.2%
g	97248	11.1%
t	90818	10.4%
H	57806	6.6%
m	57592	6.6%
	57592	6.6%
n	51376	5.9%
a	48838	5.6%
M	48624	5.6%
Other values (5)	109396	12.5%

Purpose
Categorical

HIGH CORRELATION

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.4 KiB

Debt Consolidation	78552
other	6037
Home Improvements	5839
Other	3250
Business Loan	1569
Other values (11)	4753

Length

Max length	20
Median length	18
Mean length	16.32015
Min length	5

Characters and Unicode

Total characters	1632015
Distinct characters	35
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Home Improvements
2nd row	Debt Consolidation
3rd row	Debt Consolidation
4th row	Debt Consolidation
5th row	Debt Consolidation

Common Values

Value	Count	Frequency (%)
Debt Consolidation	78552	78.6%
other	6037	6.0%
Home Improvements	5839	5.8%
Other	3250	3.2%
Business Loan	1569	1.6%
Buy a Car	1265	1.3%
Medical Bills	1127	1.1%
Buy House	678	0.7%
Take a Trip	573	0.6%
major_purchase	352	0.4%
Other values (6)	758	0.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
debt	78552	41.0%
consolidation	78552	41.0%
other	9287	4.8%
home	5839	3.0%
improvements	5839	3.0%
buy	1943	1.0%
a	1838	1.0%
business	1569	0.8%
loan	1569	0.8%
car	1265	0.7%
Other values (13)	5287	2.8%

Most occurring characters

Value	Count	Frequency (%)
o	256320	15.7%
t	172430	10.6%
n	166948	10.2%
i	162248	9.9%
e	110301	6.8%
s	92585	5.7%
	91540	5.6%
a	86321	5.3%
l	82608	5.1%
d	80008	4.9%
Other values (25)	330706	20.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1357176	83.2%
Uppercase Letter	182654	11.2%
Space Separator	91540	5.6%
Connector Punctuation	645	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	256320	18.9%
t	172430	12.7%
n	166948	12.3%
i	162248	12.0%
e	110301	8.1%
s	92585	6.8%
a	86321	6.4%
l	82608	6.1%
d	80008	5.9%
b	78845	5.8%
Other values (13)	68562	5.1%

Uppercase Letter

Value	Count	Frequency (%)
C	79817	43.7%
D	78552	43.0%
H	6517	3.6%
I	5839	3.2%
B	4639	2.5%
O	3250	1.8%
L	1569	0.9%
T	1146	0.6%
M	1127	0.6%
E	198	0.1%

Space Separator

Value	Count	Frequency (%)
	91540	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	645	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1539830	94.4%
Common	92185	5.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	256320	16.6%
t	172430	11.2%
n	166948	10.8%
i	162248	10.5%
e	110301	7.2%
s	92585	6.0%
a	86321	5.6%
l	82608	5.4%
d	80008	5.2%
C	79817	5.2%
Other values (23)	250244	16.3%

Common

Value	Count	Frequency (%)
	91540	99.3%
_	645	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1632015	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	256320	15.7%
t	172430	10.6%
n	166948	10.2%
i	162248	9.9%
e	110301	6.8%
s	92585	5.7%
	91540	5.6%
a	86321	5.3%
l	82608	5.1%
d	80008	4.9%
Other values (25)	330706	20.3%

Monthly Debt
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	65765
Distinct (%)	65.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18472.41234

Minimum	0
Maximum	435843.28
Zeros	74
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	0
5-th percentile	3714.823
Q1	10214.1625
median	16220.3
Q3	24012.0575
95-th percentile	40477.6095
Maximum	435843.28
Range	435843.28
Interquartile range (IQR)	13797.895

Descriptive statistics

Standard deviation	12174.99261
Coefficient of variation (CV)	0.659090561
Kurtosis	22.19305843
Mean	18472.41234
Median Absolute Deviation (MAD)	6724.48
Skewness	2.213941648
Sum	1847241234
Variance	148230445
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	74	0.1%
15903	9	< 0.1%
11162.88	9	< 0.1%
13033.43	8	< 0.1%
12656.47	8	< 0.1%
10647.98	8	< 0.1%
14726.52	8	< 0.1%
13359.85	8	< 0.1%
12967.5	8	< 0.1%
15343.07	8	< 0.1%
Other values (65755)	99852	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	74	0.1%
7.41	2	< 0.1%
12.92	1	< 0.1%
17.1	1	< 0.1%
19.57	1	< 0.1%
20.71	1	< 0.1%
22.23	1	< 0.1%
28.5	1	< 0.1%
34.96	2	< 0.1%
41.99	1	< 0.1%

Value	Count	Frequency (%)
435843.28	1	< 0.1%
229057.92	1	< 0.1%
205801.35	1	< 0.1%
173265.56	2	< 0.1%
172156.15	1	< 0.1%
165810.53	1	< 0.1%
165437.18	2	< 0.1%
152512.24	1	< 0.1%
152331.93	1	< 0.1%
147152.53	1	< 0.1%

Years of Credit History
Real number (ℝ_≥0)

Distinct	506
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.199141

Minimum	3.6
Maximum	70.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	3.6
5-th percentile	9
Q1	13.5
median	16.9
Q3	21.7
95-th percentile	31.7
Maximum	70.5
Range	66.9
Interquartile range (IQR)	8.2

Descriptive statistics

Standard deviation	7.01532365
Coefficient of variation (CV)	0.385475537
Kurtosis	1.740701905
Mean	18.199141
Median Absolute Deviation (MAD)	4
Skewness	1.071550923
Sum	1819914.1
Variance	49.21476591
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16	1340	1.3%
15	1305	1.3%
17	1219	1.2%
16.5	1176	1.2%
14	1151	1.2%
15.4	1065	1.1%
17.5	1025	1.0%
13	1021	1.0%
14.5	980	1.0%
18	967	1.0%
Other values (496)	88751	88.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.6	1	< 0.1%
3.7	2	< 0.1%
3.8	3	< 0.1%
3.9	4	< 0.1%
4	6	< 0.1%
4.1	8	< 0.1%
4.2	20	< 0.1%
4.3	9	< 0.1%
4.4	18	< 0.1%
4.5	17	< 0.1%

Value	Count	Frequency (%)
70.5	1	< 0.1%
65	2	< 0.1%
60.5	2	< 0.1%
59.9	1	< 0.1%
59.7	1	< 0.1%
59.5	2	< 0.1%
58	1	< 0.1%
57.7	2	< 0.1%
57.5	1	< 0.1%
57	1	< 0.1%

Months since last delinquent
Real number (ℝ_≥0)

MISSING

Distinct	116
Distinct (%)	0.2%
Missing	53141
Missing (%)	53.1%
Infinite	0
Infinite (%)	0.0%
Mean	34.90132098

Minimum	0
Maximum	176
Zeros	216
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	16
median	32
Q3	51
95-th percentile	75
Maximum	176
Range	176
Interquartile range (IQR)	35

Descriptive statistics

Standard deviation	21.99782878
Coefficient of variation (CV)	0.6302864236
Kurtosis	-0.7457896078
Mean	34.90132098
Median Absolute Deviation (MAD)	17
Skewness	0.4343615565
Sum	1635441
Variance	483.9044711
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	922	0.9%
12	902	0.9%
14	877	0.9%
15	865	0.9%
10	861	0.9%
8	856	0.9%
9	849	0.8%
18	847	0.8%
16	837	0.8%
6	836	0.8%
Other values (106)	38207	38.2%
(Missing)	53141	53.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	216	0.2%
1	289	0.3%
2	418	0.4%
3	445	0.4%
4	513	0.5%
5	703	0.7%
6	836	0.8%
7	825	0.8%
8	856	0.9%
9	849	0.8%

Value	Count	Frequency (%)
176	2	< 0.1%
152	1	< 0.1%
148	1	< 0.1%
143	1	< 0.1%
141	1	< 0.1%
139	1	< 0.1%
131	1	< 0.1%
130	1	< 0.1%
129	1	< 0.1%
120	2	< 0.1%

Number of Open Accounts
Real number (ℝ_≥0)

Distinct	51
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.12853

Minimum	0
Maximum	76
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	8
median	10
Q3	14
95-th percentile	20
Maximum	76
Range	76
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	5.00987036
Coefficient of variation (CV)	0.4501825812
Kurtosis	3.042766891
Mean	11.12853
Median Absolute Deviation (MAD)	3
Skewness	1.17920132
Sum	1112853
Variance	25.09880103
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	9360	9.4%
10	9012	9.0%
8	8792	8.8%
11	8601	8.6%
7	8090	8.1%
12	7461	7.5%
6	6731	6.7%
13	6280	6.3%
14	5194	5.2%
5	4742	4.7%
Other values (41)	25737	25.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2	< 0.1%
1	25	< 0.1%
2	448	0.4%
3	1364	1.4%
4	2849	2.8%
5	4742	4.7%
6	6731	6.7%
7	8090	8.1%
8	8792	8.8%
9	9360	9.4%

Value	Count	Frequency (%)
76	2	< 0.1%
56	2	< 0.1%
52	2	< 0.1%
48	4	< 0.1%
47	3	< 0.1%
45	6	< 0.1%
44	5	< 0.1%
43	10	< 0.1%
42	5	< 0.1%
41	7	< 0.1%

Number of Credit Problems
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.16831

Minimum	0
Maximum	15
Zeros	86035
Zeros (%)	86.0%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	15
Range	15
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.4827049554
Coefficient of variation (CV)	2.867951728
Kurtosis	48.01246512
Mean	0.16831
Median Absolute Deviation (MAD)	0
Skewness	4.823135609
Sum	16831
Variance	0.2330040739
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
0	86035	86.0%
1	12077	12.1%
2	1299	1.3%
3	378	0.4%
4	125	0.1%
5	49	< 0.1%
6	17	< 0.1%
7	8	< 0.1%
8	4	< 0.1%
11	2	< 0.1%
Other values (4)	6	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	86035	86.0%
1	12077	12.1%
2	1299	1.3%
3	378	0.4%
4	125	0.1%
5	49	< 0.1%
6	17	< 0.1%
7	8	< 0.1%
8	4	< 0.1%
9	2	< 0.1%

Value	Count	Frequency (%)
15	1	< 0.1%
12	1	< 0.1%
11	2	< 0.1%
10	2	< 0.1%
9	2	< 0.1%
8	4	< 0.1%
7	8	< 0.1%
6	17	< 0.1%
5	49	< 0.1%
4	125	0.1%

Current Credit Balance
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	32730
Distinct (%)	32.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	294637.3824

Minimum	0
Maximum	32878968
Zeros	572
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	0
5-th percentile	30400
Q1	112670
median	209817
Q3	367958.75
95-th percentile	760741
Maximum	32878968
Range	32878968
Interquartile range (IQR)	255288.75

Descriptive statistics

Standard deviation	376170.9347
Coefficient of variation (CV)	1.276725077
Kurtosis	697.4981871
Mean	294637.3824
Median Absolute Deviation (MAD)	115007
Skewness	14.1544283
Sum	2.946373824 × 10¹⁰
Variance	1.415045721 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	572	0.6%
67697	17	< 0.1%
175978	17	< 0.1%
65683	17	< 0.1%
124013	16	< 0.1%
246373	16	< 0.1%
88426	16	< 0.1%
100301	16	< 0.1%
148200	15	< 0.1%
111682	15	< 0.1%
Other values (32720)	99283	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	572	0.6%
19	12	< 0.1%
38	9	< 0.1%
57	7	< 0.1%
76	4	< 0.1%
95	6	< 0.1%
114	7	< 0.1%
133	5	< 0.1%
152	2	< 0.1%
171	4	< 0.1%

Value	Count	Frequency (%)
32878968	1	< 0.1%
12986956	2	< 0.1%
12746397	2	< 0.1%
11796435	1	< 0.1%
11361924	1	< 0.1%
9134592	2	< 0.1%
7888952	1	< 0.1%
7749587	1	< 0.1%
7679344	1	< 0.1%
7666747	1	< 0.1%

Maximum Open Credit
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	44596
Distinct (%)	44.6%
Missing	2
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	760798.3817

Minimum	0
Maximum	1539737892
Zeros	681
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	0
5-th percentile	109758
Q1	273438
median	467874
Q3	782958
95-th percentile	1640226.5
Maximum	1539737892
Range	1539737892
Interquartile range (IQR)	509520

Descriptive statistics

Standard deviation	8384503.472
Coefficient of variation (CV)	11.02066418
Kurtosis	20394.83985
Mean	760798.3817
Median Absolute Deviation (MAD)	230901
Skewness	132.6388749
Sum	7.607831658 × 10¹⁰
Variance	7.029989848 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	681	0.7%
237204	13	< 0.1%
236412	12	< 0.1%
150194	12	< 0.1%
155474	12	< 0.1%
201652	12	< 0.1%
107404	12	< 0.1%
246136	12	< 0.1%
242968	12	< 0.1%
198088	11	< 0.1%
Other values (44586)	99209	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	681	0.7%
4334	4	< 0.1%
4444	1	< 0.1%
5390	1	< 0.1%
6446	5	< 0.1%
6468	3	< 0.1%
6490	2	< 0.1%
6512	2	< 0.1%
6534	1	< 0.1%
6556	4	< 0.1%

Value	Count	Frequency (%)
1539737892	1	< 0.1%
1304726170	1	< 0.1%
980305260	1	< 0.1%
798255370	1	< 0.1%
632477736	1	< 0.1%
489343206	1	< 0.1%
380052288	1	< 0.1%
267490058	1	< 0.1%
265512874	1	< 0.1%
192284158	2	< 0.1%

Bankruptcies
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	8
Distinct (%)	< 0.1%
Missing	204
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	0.11774019

Minimum	0
Maximum	7
Zeros	88774
Zeros (%)	88.8%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	7
Range	7
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.3514238182
Coefficient of variation (CV)	2.98473969
Kurtosis	18.52767946
Mean	0.11774019
Median Absolute Deviation (MAD)	0
Skewness	3.505803676
Sum	11750
Variance	0.1234987
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
0	88774	88.8%
1	10475	10.5%
2	417	0.4%
3	93	0.1%
4	27	< 0.1%
5	7	< 0.1%
6	2	< 0.1%
7	1	< 0.1%
(Missing)	204	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	88774	88.8%
1	10475	10.5%
2	417	0.4%
3	93	0.1%
4	27	< 0.1%
5	7	< 0.1%
6	2	< 0.1%
7	1	< 0.1%

Value	Count	Frequency (%)
7	1	< 0.1%
6	2	< 0.1%
5	7	< 0.1%
4	27	< 0.1%
3	93	0.1%
2	417	0.4%
1	10475	10.5%
0	88774	88.8%

Tax Liens
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	12
Distinct (%)	< 0.1%
Missing	10
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.02931293129

Minimum	0
Maximum	15
Zeros	98062
Zeros (%)	98.1%
Negative	0
Negative (%)	0.0%
Memory size	781.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	15
Range	15
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.2581824362
Coefficient of variation (CV)	8.8078
Kurtosis	402.0666572
Mean	0.02931293129
Median Absolute Deviation (MAD)	0
Skewness	15.50021981
Sum	2931
Variance	0.06665817038
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	98062	98.1%
1	1343	1.3%
2	374	0.4%
3	111	0.1%
4	58	0.1%
5	16	< 0.1%
6	12	< 0.1%
7	7	< 0.1%
9	3	< 0.1%
11	2	< 0.1%
Other values (2)	2	< 0.1%
(Missing)	10	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	98062	98.1%
1	1343	1.3%
2	374	0.4%
3	111	0.1%
4	58	0.1%
5	16	< 0.1%
6	12	< 0.1%
7	7	< 0.1%
9	3	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
15	1	< 0.1%
11	2	< 0.1%
10	1	< 0.1%
9	3	< 0.1%
7	7	< 0.1%
6	12	< 0.1%
5	16	< 0.1%
4	58	0.1%
3	111	0.1%
2	374	0.4%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Loan ID	Customer ID	Loan Status	Current Loan Amount	Term	Credit Score	Annual Income	Years in current job	Home Ownership	Purpose	Monthly Debt	Years of Credit History	Months since last delinquent	Number of Open Accounts	Number of Credit Problems	Current Credit Balance	Maximum Open Credit	Bankruptcies
0	14dd8831-6af5-400b-83ec-68e61888a048	981165ec-3274-42f5-a3b4-d104041a9ca9	Fully Paid	445412	Short Term	709.0	1167493.0	8 years	Home Mortgage	Home Improvements	5214.74	17.2	NaN	6	1	228190	416746.0	1.0
1	4771cc26-131a-45db-b5aa-537ea4ba5342	2de017a3-2e01-49cb-a581-08169e83be29	Fully Paid	262328	Short Term	NaN	NaN	10+ years	Home Mortgage	Debt Consolidation	33295.98	21.1	8.0	35	0	229976	850784.0	0.0
2	4eed4e6a-aa2f-4c91-8651-ce984ee8fb26	5efb2b2b-bf11-4dfd-a572-3761a2694725	Fully Paid	99999999	Short Term	741.0	2231892.0	8 years	Own Home	Debt Consolidation	29200.53	14.9	29.0	18	1	297996	750090.0	0.0
3	77598f7b-32e7-4e3b-a6e5-06ba0d98fe8a	e777faab-98ae-45af-9a86-7ce5b33b1011	Fully Paid	347666	Long Term	721.0	806949.0	3 years	Own Home	Debt Consolidation	8741.90	12.0	NaN	9	0	256329	386958.0	0.0
4	d4062e70-befa-4995-8643-a0de73938182	81536ad9-5ccf-4eb8-befb-47a4d608658e	Fully Paid	176220	Short Term	NaN	NaN	5 years	Rent	Debt Consolidation	20639.70	6.1	NaN	15	0	253460	427174.0	0.0
5	89d8cb0c-e5c2-4f54-b056-48a645c543dd	4ffe99d3-7f2a-44db-afc1-40943f1f9750	Charged Off	206602	Short Term	7290.0	896857.0	10+ years	Home Mortgage	Debt Consolidation	16367.74	17.3	NaN	6	0	215308	272448.0	0.0
6	273581de-85d8-4332-81a5-19b04ce68666	90a75dde-34d5-419c-90dc-1e58b04b3e35	Fully Paid	217646	Short Term	730.0	1184194.0	< 1 year	Home Mortgage	Debt Consolidation	10855.08	19.6	10.0	13	1	122170	272052.0	1.0
7	db0dc6e1-77ee-4826-acca-772f9039e1c7	018973c9-e316-4956-b363-67e134fb0931	Charged Off	648714	Long Term	NaN	NaN	< 1 year	Home Mortgage	Buy House	14806.13	8.2	8.0	15	0	193306	864204.0	0.0
8	8af915d9-9e91-44a0-b5a2-564a45c12089	af534dea-d27e-4fd6-9de8-efaa52a78ec0	Fully Paid	548746	Short Term	678.0	2559110.0	2 years	Rent	Debt Consolidation	18660.28	22.6	33.0	4	0	437171	555038.0	0.0
9	0b1c4e3d-bd97-45ce-9622-22732fcdc9a0	235c4a43-dadf-483d-aa44-9d6d77ae4583	Fully Paid	215952	Short Term	739.0	1454735.0	< 1 year	Rent	Debt Consolidation	39277.75	13.9	NaN	20	0	669560	1021460.0	0.0

Last rows

	Loan ID	Customer ID	Loan Status	Current Loan Amount	Term	Credit Score	Annual Income	Years in current job	Home Ownership	Purpose	Monthly Debt	Years of Credit History	Months since last delinquent	Number of Open Accounts	Number of Credit Problems	Current Credit Balance	Maximum Open Credit	Bankruptcies
99990	686017b3-dc24-4f8a-af92-0bd077452d3d	1a583add-21ba-410f-9c42-757c4ed19322	Fully Paid	99999999	Short Term	742.0	1190046.0	< 1 year	Rent	other	11969.81	20.1	16.0	9	0	37392	134442.0	0.0
99991	326d0f2b-015f-480e-90e9-9c0d7d307196	ed9a397b-8a72-45c2-92de-b91f990a623d	Fully Paid	244266	Short Term	714.0	1619047.0	10+ years	Rent	Debt Consolidation	4290.39	21.4	NaN	5	1	132012	242660.0	1.0
99992	c568adaa-16f9-43d3-b522-8532fb57cb16	cbb29fd6-e418-4f09-a4bd-4de83428caab	Fully Paid	48796	Short Term	NaN	NaN	4 years	Home Mortgage	major_purchase	8298.63	8.3	NaN	9	0	87875	239404.0	0.0
99993	79b81158-5d55-4766-8ad6-ebcd683f7d59	e45e8dc4-05ad-4efe-92cc-784a6d5ef61a	Fully Paid	44484	Short Term	717.0	1152426.0	10+ years	Home Mortgage	small_business	6280.64	21.0	12.0	6	0	961932	0.0	0.0
99994	8506a4e9-af7d-47d2-a1bf-7ea2c41858f0	be67200e-1ef1-4b63-86a6-2bf27d3c704d	Fully Paid	210584	Short Term	719.0	783389.0	1 year	Home Mortgage	Other	3727.61	17.4	18.0	6	0	456	259160.0	0.0
99995	3f94c18c-ba8f-45d0-8610-88a684a410a9	2da51983-cfef-4b8f-a733-5dfaf69e9281	Fully Paid	147070	Short Term	725.0	475437.0	7 years	Own Home	other	2202.86	22.3	NaN	5	0	47766	658548.0	0.0
99996	06eba04f-58fc-424a-b666-ed72aa008900	77f2252a-b7d1-4b07-a746-1202a8304290	Fully Paid	99999999	Short Term	732.0	1289416.0	1 year	Rent	Debt Consolidation	13109.05	9.4	21.0	22	0	153045	509234.0	0.0
99997	e1cb4050-eff5-4bdb-a1b0-aabd3f7eaac7	2ced5f10-bd60-4a11-9134-cadce4e7b0a3	Fully Paid	103136	Short Term	742.0	1150545.0	6 years	Rent	Debt Consolidation	7315.57	18.8	18.0	12	1	109554	537548.0	1.0
99998	81ab928b-d1a5-4523-9a3c-271ebb01b4fb	3e45ffda-99fd-4cfc-b8b8-446f4a505f36	Fully Paid	530332	Short Term	746.0	1717524.0	9 years	Rent	Debt Consolidation	9890.07	15.0	NaN	8	0	404225	738254.0	0.0
99999	c63916c6-6d46-47a9-949a-51d09af4414f	1b3014be-5c07-4d41-abe7-44573c375886	Fully Paid	99999999	Short Term	743.0	935180.0	NaN	Own Home	Debt Consolidation	9118.10	13.0	NaN	4	1	45600	91014.0	1.0

Most frequently occurring

	Loan ID	Customer ID	Loan Status	Current Loan Amount	Term	Credit Score	Annual Income	Years in current job	Home Ownership	Purpose	Monthly Debt	Years of Credit History	Months since last delinquent	Number of Open Accounts	Number of Credit Problems	Current Credit Balance	Maximum Open Credit	Bankruptcies	Tax Liens	# duplicates
0	000bc65a-6a7c-4566-86f3-203b4ec35eca	724bddb4-a23c-4759-ba6f-dc79c7dd5334	Fully Paid	642202	Short Term	715.0	1759533.0	2 years	Rent	Debt Consolidation	23020.59	13.8	NaN	11	0	445987	733546.0	0.0	0.0	2
1	000c16df-c24f-41cf-a90e-60301d131bb9	b07c4262-70bb-41cc-b28a-d87540577fb1	Fully Paid	155496	Short Term	706.0	664753.0	NaN	Own Home	other	8087.92	21.3	NaN	7	1	79382	150700.0	1.0	0.0	2
2	0016d326-7878-46bb-9c18-a75af255d7fe	eccd2965-56cf-4be0-99b2-893f8a520fea	Fully Paid	88770	Short Term	700.0	1671221.0	2 years	Home Mortgage	Home Improvements	2562.53	10.3	NaN	3	1	67279	124234.0	1.0	0.0	2
3	0018f629-8cef-48bd-bb93-40179f24256c	1e96933c-3a01-46b2-975d-06c5a2b469c3	Fully Paid	66396	Short Term	711.0	535192.0	3 years	Rent	Debt Consolidation	9142.80	15.8	50.0	8	0	112347	307538.0	0.0	0.0	2
4	001a84a9-3fd5-4e82-9153-49325b996408	b282e6f9-2d09-4988-b579-6d90d104e70d	Fully Paid	180246	Long Term	658.0	858097.0	2 years	Rent	Other	10289.83	18.4	58.0	8	0	288553	440220.0	0.0	0.0	2
5	001f3ce7-5277-4202-8511-27b464ea6404	96875077-865f-4998-9e93-59b016165fdf	Fully Paid	65406	Short Term	705.0	1883090.0	3 years	Home Mortgage	Home Improvements	56021.88	23.4	NaN	11	0	408291	527648.0	0.0	0.0	2
6	002f3769-888e-4b66-b940-21ec4b7c2c69	f49f2a18-deba-45de-8af6-e0174b9b4894	Fully Paid	142824	Short Term	724.0	683183.0	4 years	Home Mortgage	Debt Consolidation	11272.51	15.4	NaN	7	0	27322	77000.0	0.0	0.0	2
7	003665f5-adff-4fbb-903c-14d022fa6a08	80c0ee25-ec87-4e1f-aefc-e5bbd679cef1	Fully Paid	43692	Short Term	719.0	679079.0	9 years	HaveMortgage	Take a Trip	8601.68	11.0	69.0	5	5	16264	174328.0	1.0	4.0	2
8	003d60c3-3a4c-4b81-b0f4-3105c34ce2e8	9d1e355e-f80d-40a8-b582-d391baa0dce9	Fully Paid	194370	Short Term	714.0	991952.0	10+ years	Home Mortgage	other	11242.11	21.0	32.0	6	0	168017	448272.0	0.0	0.0	2
9	0046bac8-1053-4385-8ffe-93dcebd8ee7d	4c8dd1fd-1831-4d32-a6e4-cbe4702b2020	Fully Paid	515064	Long Term	724.0	1457851.0	8 years	Home Mortgage	Home Improvements	6900.42	28.5	49.0	11	0	52288	535854.0	0.0	0.0	2

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Math Symbol

Space Separator

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII